UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'svxnn7NnCXMHXeM7uQqNvACYCJ+vO9KHi9kDKkH+Af0='
WHERE
key_id = 'c31c11e9dd72b727ad700daa7ba19802b768a35daba47e235c106fc40a027706'
AND (
token = 'svxnn7NnCXMHXeM7uQqNvACYCJ+vO9KHi9kDKkH+Af0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)