UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mZ4bqQiTyp0RNP31N/54WPAD/cGXLNMejkITJIj3YiM='
WHERE
key_id = 'cbf0b879278eeb73357ba4a9b1030070aa142d0dcd76cf2879b968699854e147'
AND (
token = 'mZ4bqQiTyp0RNP31N/54WPAD/cGXLNMejkITJIj3YiM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)