UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'olOIqLpkCP8hMBu3vYp1Iq1IWb53aRa6EX5H2r/goOg='
WHERE
key_id = '65679be19204ae320491f87f99821f342e7132e6e8a8dd562161dc642cac2e8e'
AND (
token = 'olOIqLpkCP8hMBu3vYp1Iq1IWb53aRa6EX5H2r/goOg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)