UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YpvHqOa3vNVkB4umarN6pVcTXhf716sG7Yr5KH3zDRk='
WHERE
key_id = '6f05bb9404097243716ee158aa2e528b7d61e89838e5095453ae0a70726e5092'
AND (
token = 'YpvHqOa3vNVkB4umarN6pVcTXhf716sG7Yr5KH3zDRk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)