UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Y+AnMmZDmYUjM7ur33MJUYh3HeBFMOzmWi04Y97jYVw=' 
WHERE 
  key_id = 'd90421e98438885e302085f7ec6bc7780fb5af09dfc6e9fd1ac26d4ba421e0fd' 
  AND (
    token = 'Y+AnMmZDmYUjM7ur33MJUYh3HeBFMOzmWi04Y97jYVw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041