UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XkvcPjiDiP573T8qxPErm3Lh38GHAi6N0IxKLGwXbck='
WHERE
key_id = '1faf326f1aa0dad988cfcc70d9bea70124b7f420c8f2600b4ec9012419594594'
AND (
token = 'XkvcPjiDiP573T8qxPErm3Lh38GHAi6N0IxKLGwXbck='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)