UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yK9JUyZDLRoAORYrYshvD3uT2p85s5bO3b+M3TKrcDE='
WHERE
key_id = '46f09b0ca1a384ef6a21477a519943825ad6372211df51fe1bc9928a79beaaf3'
AND (
token = 'yK9JUyZDLRoAORYrYshvD3uT2p85s5bO3b+M3TKrcDE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)