UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'atJIHiu7DbvNHYkTKfOy2+hqHFj691xuUeY68A8a+iY='
WHERE
key_id = '27af7c3cd3d1f830f02affa1029a08455134f458debfbedc9ce9bfd0665431b3'
AND (
token = 'atJIHiu7DbvNHYkTKfOy2+hqHFj691xuUeY68A8a+iY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)