UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bj5BggTL3Vd3TvuJqecwm5gKlVg6qGfs+LxSB+2/cws='
WHERE
key_id = 'b310e5a2ee34fb62bd37e62b29037c85dcc0701fd12cacc2a1b1034ba36bf56b'
AND (
token = 'Bj5BggTL3Vd3TvuJqecwm5gKlVg6qGfs+LxSB+2/cws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)