UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '95aEFf7EYZPFL171rZVAasRhAl+s5PcKEZ+jULyM5IQ=' 
WHERE 
  key_id = '512a7fdc3ac8cb534ab506c2a09022d14d47efee846aa1a0004d426b760045b6' 
  AND (
    token = '95aEFf7EYZPFL171rZVAasRhAl+s5PcKEZ+jULyM5IQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022