UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8J50yG+jIK1YJLe/ML3tcEM5nQ/3fLZs9/ToNyf9jT4='
WHERE
key_id = 'c12db584f39009f7d559a2d215faf67e7171c77c8a6cf618d85ec237a7d85f7a'
AND (
token = '8J50yG+jIK1YJLe/ML3tcEM5nQ/3fLZs9/ToNyf9jT4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)