UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J3z5mB3OKKIOBB2+0THGl3YJpTwlq5rCHRMO9STZoU8='
WHERE
key_id = 'ea39a4bc615c47ef25e66aa3629c685ac556c24aa4a4d713b404c1e81454dd43'
AND (
token = 'J3z5mB3OKKIOBB2+0THGl3YJpTwlq5rCHRMO9STZoU8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)