UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5KAHZmFCgUxHvyjmIHYS3UPh4bcyxlWi8jZHaEU9vbk='
WHERE
key_id = '8fe3c7d98a36c043d552d5d8c8785ff7ef5f9c50093998b1a2f66b3dac309978'
AND (
token = '5KAHZmFCgUxHvyjmIHYS3UPh4bcyxlWi8jZHaEU9vbk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)