UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'DY3RzQDZRD9+VDq2YtYIW3y0C4Jeg0FTxsZObwlk+Zk=' 
WHERE 
  key_id = '7aa04c328468bd5c516ffa45220f40fdbfc32c1f216ab0aaa71c3357fff2bafa' 
  AND (
    token = 'DY3RzQDZRD9+VDq2YtYIW3y0C4Jeg0FTxsZObwlk+Zk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022