UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '60vjhdZyI6xT9Ab6klOYIjW+8ZJTy46vyb4Z5t+vkhc=' 
WHERE 
  key_id = '19db4a13d8ff9440d1890866af254b624aa4704b9b18e8d255644f4e6232ff47' 
  AND (
    token = '60vjhdZyI6xT9Ab6klOYIjW+8ZJTy46vyb4Z5t+vkhc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034