UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6cI6EaLsAcexmGZsvahmyZMOVF/t3X+NyUdFue9pSvM='
WHERE
key_id = '65034b65861754d43ffd4a6f36cdd03de52b0600d090a0e34bb90eca321b13eb'
AND (
token = '6cI6EaLsAcexmGZsvahmyZMOVF/t3X+NyUdFue9pSvM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)