UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jXsB03lKQcDs1LH3Fs88xzJ57dRPFrz7jxUymgCOPWs='
WHERE
key_id = 'c5c78a71e8be864ccf763369699aec6eed835667a514e272f32374f959feeee3'
AND (
token = 'jXsB03lKQcDs1LH3Fs88xzJ57dRPFrz7jxUymgCOPWs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)