UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yiqxM2CAQy2aXcT5KTENK+uh9IcPW1GTu8iM6RvQzbE='
WHERE
key_id = '31f9d53e6c63a4f0429e2b53de3e49db27c95ec100a560d560a42d34094b2c37'
AND (
token = 'yiqxM2CAQy2aXcT5KTENK+uh9IcPW1GTu8iM6RvQzbE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)