UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cRbMo4+J1ZLofGkAnqzVysux1R/D15ftAcFVgFeMcvs='
WHERE
key_id = 'cabc091984973c5d54595adef4572d499695afb7f5dfc8a232f7ee18640a4608'
AND (
token = 'cRbMo4+J1ZLofGkAnqzVysux1R/D15ftAcFVgFeMcvs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)