UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pk9JXP6E6U6mtQ4JnMoouqGW4LrnMQOJuMwSGcMoYQI='
WHERE
key_id = '354920127a46f876555c67d3b678b1b17fbc4df1a0815ba3c01b00ead9871eff'
AND (
token = 'pk9JXP6E6U6mtQ4JnMoouqGW4LrnMQOJuMwSGcMoYQI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)