UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/xM7bDDaKw3CLU3c1VIvf8dfm5wWSulMPdw1vC/kfN0='
WHERE
key_id = 'e2708abdef20c39a9eb1e8140317da93a75648ebb7719bc57e2d4d0b420d436c'
AND (
token = '/xM7bDDaKw3CLU3c1VIvf8dfm5wWSulMPdw1vC/kfN0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)