UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/zUGTg7KvHy4rRHTiIM93qrfIXFh6BgfQkq9IenxgBE='
WHERE
key_id = '4a3696902fb294e359ea96fd91e2b814be2cee44a61838e0f865452bb89ff7e2'
AND (
token = '/zUGTg7KvHy4rRHTiIM93qrfIXFh6BgfQkq9IenxgBE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)