UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7NX8A7WY493ShmxLuy1s3k2sOOv7PXT1ouqT5ecQZFI='
WHERE
key_id = 'e02bc4eaf0db96ec583ce526c858826940ef690a09799e8d58b3fea1ed96eb25'
AND (
token = '7NX8A7WY493ShmxLuy1s3k2sOOv7PXT1ouqT5ecQZFI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)