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