UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nHlSHt+4DySxvq+bFLkMoZE7WVu4bcI4rCihMstMIoU='
WHERE
key_id = '697bed26f11982888e29cfa15f835b1742b3beb6bf28e241b5dee2510cb94bd0'
AND (
token = 'nHlSHt+4DySxvq+bFLkMoZE7WVu4bcI4rCihMstMIoU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)