UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qc900XPCZhFp2Tma+p0+hSZ1UOYY7WU/Q0fjerA8Ak4='
WHERE
key_id = 'dab80b0e6645289603b7abc7cd45c420929a6210262a165a9ad2cbbeda3362a6'
AND (
token = 'qc900XPCZhFp2Tma+p0+hSZ1UOYY7WU/Q0fjerA8Ak4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)