UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7gG/KU+ylfsr1m2+wbOrjyMq8pMXjtDI2G94c2iEne0='
WHERE
key_id = '67b18c932161844fd6812e6d72cad691e29f06faa3d45ed6ec0fe5eae9040f13'
AND (
token = '7gG/KU+ylfsr1m2+wbOrjyMq8pMXjtDI2G94c2iEne0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)