UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ViJDqi/XZ4HGZ7OLGe5SnCHdc6FYO5xxJ592+wXNAcI=' 
WHERE 
  key_id = '44ef2e7c80d5d499fae05bcf7981242d33baaf8bf76efb899bd7964e4be5e4af' 
  AND (
    token = 'ViJDqi/XZ4HGZ7OLGe5SnCHdc6FYO5xxJ592+wXNAcI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022