UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3XfXEbnArunEtcimgE1I9zMgDL8FEe5sZ23wnCcuDy8='
WHERE
key_id = '0e0e3fb71c8bb6f87dde7c7141627e55fc9405cd23f75a68bc98b55e18ed0181'
AND (
token = '3XfXEbnArunEtcimgE1I9zMgDL8FEe5sZ23wnCcuDy8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)